package com.project.scheduled.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface GjBusMapper extends BaseMapper {
    @Select("{call insert_XL_PC_GPS_ZaiXian_day_UPDATE(#{date, mode=IN, jdbcType=VARCHAR})}")
    public void  insert_XL_PC_GPS_ZaiXian_day_UPDATE(@Param("date")String date);
    @Select("{call insert_XL_PC_GPS_ZaiXian_month_UPDATE(#{date, mode=IN, jdbcType=VARCHAR})}")
    public void insert_XL_PC_GPS_ZaiXian_month_UPDATE(@Param("date")String date);
    @Select("{call UPDATE_CZXL_JGXL()}")
    public void UPDATE_CZXL_JGXL();
    @Select("{call updateJGCLXL()}")
    public void updateJGCLXL();
    @Select("{call pro_XLBCSK()}")
    public void pro_XLBCSK();
    @Select("{call insert_XLSKB_DAY(#{date, mode=IN, jdbcType=VARCHAR})}")
    public void insert_XLSKB_DAY(@Param("date")String date);
    @Select("{call pro_Update_XLSKB_EXTEND()}")
    public void pro_Update_XLSKB_EXTEND();

    @Select("{call upd_zd()}")
    public void upd_zd();
    @Select("select * into GJ_BUS_BAK.dbo.JG_GJXLZD_BACKUP_#{date,jdbcType=VARCHAR}  from  gJ_BUS.dbo.JG_GJXLZD ")
    public void insertJG_GJXLZD_BACKUP(@Param("date")String date);
    @Select("truncate table    [GJ_BUS].[dbo].[JG_GJXLZD_THE_DAY_BEFORE_YESTERDAY]")
    public void truncateJG_GJXLZD_THE_DAY_BEFORE_YESTERDAY();

    @Select("insert into  [GJ_BUS].[dbo].[JG_GJXLZD_THE_DAY_BEFORE_YESTERDAY]  select * from GJ_BUS_BAK.dbo.JG_GJXLZD_BACKUP_#{date,jdbcType=VARCHAR}")
    public void insertJG_GJXLZD_THE_DAY_BEFORE_YESTERDAY(@Param("date")String date);

    @Select("{call cleanRawMsg()}")
    public void  cleanRawMsg();

}
